DELETE FROM dbo.[CSK_Store_TransactionType]

DELETE FROM dbo.[CSK_CouponTypes]

DELETE FROM dbo.[CSK_Messaging_Mailer]

DELETE FROM dbo.[CSK_Shipping_Rate]

DELETE FROM dbo.[CSK_Stats_Behavior]

DELETE FROM dbo.[CSK_Store_OrderStatus]

DELETE FROM dbo.[CSK_Store_AttributeType]

DELETE FROM dbo.[CSK_Store_ProductStatus]

DELETE FROM dbo.[CSK_Store_ProductType]

DELETE FROM dbo.[CSK_Store_ShippingType]

DELETE FROM dbo.[CSK_Store_ShippingEstimate]

DELETE FROM dbo.[CSK_Tax_Type]


SET IDENTITY_INSERT dbo.[CSK_Store_TransactionType] ON
PRINT 'Begin inserting data in CSK_Store_TransactionType'
INSERT INTO  dbo.[CSK_Store_TransactionType] ([transactionTypeID],[transactionType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Credit Card Payment', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_TransactionType] ([transactionTypeID],[transactionType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 'PayPal Payment', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_TransactionType] ([transactionTypeID],[transactionType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(3, 'Refund', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_TransactionType] ([transactionTypeID],[transactionType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(4, 'Purchase Order', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_TransactionType] ([transactionTypeID],[transactionType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(5, 'Offline Credit Card Payment', '5/12/2006 3:03:11 PM', NULL, '5/12/2006 3:03:11 PM', NULL)
INSERT INTO  dbo.[CSK_Store_TransactionType] ([transactionTypeID],[transactionType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(6, 'GoogleCheckout', '5/12/2006 3:03:11 PM', NULL, '5/12/2006 3:03:11 PM', NULL)
SET IDENTITY_INSERT dbo.[CSK_Store_TransactionType] OFF
PRINT 'Finished inserting data in CSK_Store_TransactionType'


SET IDENTITY_INSERT dbo.[CSK_CouponTypes] ON
PRINT 'Begin inserting data in CSK_CouponTypes'
INSERT INTO  dbo.[CSK_CouponTypes] ([CouponTypeId],[Description],[ProcessingClassName],[IsAspClass]) VALUES(1, 'Percent off order', 'Commerce.Promotions.PercentOffCoupon', 0)
SET IDENTITY_INSERT dbo.[CSK_CouponTypes] OFF
PRINT 'Finished inserting data in CSK_CouponTypes'


SET IDENTITY_INSERT dbo.[CSK_Messaging_Mailer] ON
PRINT 'Begin inserting data in CSK_Messaging_Mailer'
INSERT [dbo].[CSK_Messaging_Mailer] ([mailerID], [mailerName], [toList], [ccList], [fromName], [fromEmail], [subject], [messageBody], [isHTML], [isSystemMailer], [createdOn], [createdBy], [modifiedOn], [modifiedBy]) VALUES (1, N'Order Received - Merchant', N'merchant_mail_account@yourstore.com', N'', N'Commerce for Umbraco - Site', N'merchant_mail_account@yourstore.com', N'Order Received'
, N'You ve got an order!', 1, 1, NULL, NULL, CAST(0x000099B8010D38E1 AS DateTime), N'admin')
INSERT [dbo].[CSK_Messaging_Mailer] ([mailerID], [mailerName], [toList], [ccList], [fromName], [fromEmail], [subject], [messageBody], [isHTML], [isSystemMailer], [createdOn], [createdBy], [modifiedOn], [modifiedBy]) VALUES (2, N'Order Received - Customer', N'', N'merchant_mail_account@yourstore.com', N'Commerce for Umbraco - Site', N'merchant_mail_account@yourstore.com', N'Your Order Was Received!', N'
Your can use these items in your mail to customize it: 
#NAME#
#SITELINK#
#ORDER#
#STOREEMAIL#', 1, 1, NULL, NULL, CAST(0x000099B8010B5556 AS DateTime), N'admin')
INSERT [dbo].[CSK_Messaging_Mailer] ([mailerID], [mailerName], [toList], [ccList], [fromName], [fromEmail], [subject], [messageBody], [isHTML], [isSystemMailer], [createdOn], [createdBy], [modifiedOn], [modifiedBy]) VALUES (3, N'Shipping Notification - Customer', N'', N'', N'Shipping', N'merchant_mail_account@yourstore.com', N'Your Order Was Shipped!', N'
Here you can include the
#TRACKINGNUMBER#', 1, 1, NULL, NULL, CAST(0x000099B80115C4D3 AS DateTime), N'admin')
INSERT [dbo].[CSK_Messaging_Mailer] ([mailerID], [mailerName], [toList], [ccList], [fromName], [fromEmail], [subject], [messageBody], [isHTML], [isSystemMailer], [createdOn], [createdBy], [modifiedOn], [modifiedBy]) VALUES (4, N'Order Cancellation - Customer', N'', N'', N'Commerce for Umbraco - Site', N'merchant_mail_account@yourstore.com', N'Order Cancellation'
, N'Order was cancelled', 1, 1, NULL, NULL, CAST(0x000099B801162A2D AS DateTime), N'admin')
INSERT [dbo].[CSK_Messaging_Mailer] ([mailerID], [mailerName], [toList], [ccList], [fromName], [fromEmail], [subject], [messageBody], [isHTML], [isSystemMailer], [createdOn], [createdBy], [modifiedOn], [modifiedBy]) VALUES (5, N'Order Refund - Customer', N'', N'', N'Commerce for Umbraco - Site', N'merchant_mail_account@yourstore.com', N'Order Refunded'
, N'Order was refunded'
, 1, 1, NULL, NULL, CAST(0x000099B801166BAC AS DateTime), N'admin')
SET IDENTITY_INSERT dbo.[CSK_Messaging_Mailer] OFF
PRINT 'Finished inserting data in CSK_Messaging_Mailer'


SET IDENTITY_INSERT dbo.[CSK_Shipping_Rate] ON
PRINT 'Begin inserting data in CSK_Shipping_Rate'
INSERT INTO  dbo.[CSK_Shipping_Rate] ([shippingRateID],[Service],[Rate],[AmountPerUnit],[isAirOnly],[isGroundOnly],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Ground', NULL, 1.5000, 0, 1, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Shipping_Rate] ([shippingRateID],[Service],[Rate],[AmountPerUnit],[isAirOnly],[isGroundOnly],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 'Next Day', NULL, 2.1000, 1, 0, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Shipping_Rate] ([shippingRateID],[Service],[Rate],[AmountPerUnit],[isAirOnly],[isGroundOnly],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(3, 'Priority Overnite', NULL, 5.0000, 1, 0, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Shipping_Rate] ([shippingRateID],[Service],[Rate],[AmountPerUnit],[isAirOnly],[isGroundOnly],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(4, 'Freight', NULL, 0.5000, 0, 1, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT dbo.[CSK_Shipping_Rate] OFF
PRINT 'Finished inserting data in CSK_Shipping_Rate'


SET IDENTITY_INSERT dbo.[CSK_Stats_Behavior] ON
PRINT 'Begin inserting data in CSK_Stats_Behavior'
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Browsing Category', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 'Browsing Product', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(3, 'Clicking On Ad', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(4, 'Clicking On Promo', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(5, 'Clicking On Upsell', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(6, 'Clicking On Cross-sell', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(7, 'Clicking On Bundle', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(8, 'Running Search', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(9, 'Adding Item To Cart', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(10, 'Checking Out', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(11, 'Paying', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(12, 'Viewing Receipt', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(13, 'Removing Item From Cart', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(14, 'Adjusting Quantity', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(15, 'Logging In', '5/26/2006 2:07:19 PM', NULL, '5/26/2006 2:07:19 PM', NULL)
INSERT INTO  dbo.[CSK_Stats_Behavior] ([behaviorID],[behavior],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(16, 'Logging Out', '5/26/2006 2:07:24 PM', NULL, '5/26/2006 2:07:24 PM', NULL)
SET IDENTITY_INSERT dbo.[CSK_Stats_Behavior] OFF
PRINT 'Finished inserting data in CSK_Stats_Behavior'


PRINT 'Begin inserting data in CSK_Store_OrderStatus'
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Received, Awaiting Payment', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(10, 'Received Payment, Processing Order', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(20, 'Gathering Items From Inventory', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(30, 'Awating Shipment To Customer', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(50, 'Delayed, Items Not Available', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(100, 'Shipped To Customer', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(60, 'Delayed - Rerouting Shipping', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(70, 'Delayed - Customer Request', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(80, 'Delayed - Order Under Review', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(99, 'Order Cancelled Prior To Shipping', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(200, 'Order Refunded', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_OrderStatus] ([OrderStatusID],[OrderStatus],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(9999, 'Not Processed', '7/25/2006 11:59:00 AM', NULL, '7/25/2006 11:59:00 AM', NULL)
PRINT 'Finished inserting data in CSK_Store_OrderStatus'


SET IDENTITY_INSERT dbo.[CSK_Store_AttributeType] ON
PRINT 'Begin inserting data in CSK_Store_AttributeType'
INSERT INTO  dbo.[CSK_Store_AttributeType] ([attributeTypeID],[attributeType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Single Selection List', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_AttributeType] ([attributeTypeID],[attributeType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 'Multi-select list', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_AttributeType] ([attributeTypeID],[attributeType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(3, 'User Input', NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT dbo.[CSK_Store_AttributeType] OFF
PRINT 'Finished inserting data in CSK_Store_AttributeType'


SET IDENTITY_INSERT dbo.[CSK_Store_ProductStatus] ON
PRINT 'Begin inserting data in CSK_Store_ProductStatus'
INSERT INTO  dbo.[CSK_Store_ProductStatus] ([statusID],[status],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Active', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductStatus] ([statusID],[status],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 'New!', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductStatus] ([statusID],[status],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(3, 'On Backorder', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductStatus] ([statusID],[status],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(4, 'Top Seller', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductStatus] ([statusID],[status],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(5, 'Featured (Category)', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductStatus] ([statusID],[status],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(6, 'Discontinued (Special Order)', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductStatus] ([statusID],[status],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(7, 'No Longer Available', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductStatus] ([statusID],[status],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(8, 'Future Release', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductStatus] ([statusID],[status],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(99, 'Inactive (don''t display)', NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT dbo.[CSK_Store_ProductStatus] OFF
PRINT 'Finished inserting data in CSK_Store_ProductStatus'


SET IDENTITY_INSERT dbo.[CSK_Store_ProductType] ON
PRINT 'Begin inserting data in CSK_Store_ProductType'
INSERT INTO  dbo.[CSK_Store_ProductType] ([productTypeID],[productType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Downloadable Software', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductType] ([productTypeID],[productType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 'Books', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductType] ([productTypeID],[productType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(3, 'Electronic Goods', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductType] ([productTypeID],[productType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(4, 'Software - Ship Only', NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ProductType] ([productTypeID],[productType],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(5, 'Retail Items', NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT dbo.[CSK_Store_ProductType] OFF
PRINT 'Finished inserting data in CSK_Store_ProductType'


SET IDENTITY_INSERT dbo.[CSK_Store_ShippingType] ON
PRINT 'Begin inserting data in CSK_Store_ShippingType'
INSERT INTO  dbo.[CSK_Store_ShippingType] ([shippingTypeID],[shippingType],[shippingCode],[isDownloadable],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Normal Shipping', 'SHIP', 0, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ShippingType] ([shippingTypeID],[shippingType],[shippingCode],[isDownloadable],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 'Air Only', 'AIR', 0, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ShippingType] ([shippingTypeID],[shippingType],[shippingCode],[isDownloadable],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(3, 'Download Only', 'DOWNLOAD', 1, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT dbo.[CSK_Store_ShippingType] OFF
PRINT 'Finished inserting data in CSK_Store_ShippingType'


SET IDENTITY_INSERT dbo.[CSK_Store_ShippingEstimate] ON
PRINT 'Begin inserting data in CSK_Store_ShippingEstimate'
INSERT INTO  dbo.[CSK_Store_ShippingEstimate] ([shipEstimateID],[shippingEstimate],[leadTimeDays],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Immediate', 0, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ShippingEstimate] ([shipEstimateID],[shippingEstimate],[leadTimeDays],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 'Within 24 Hours', 0, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ShippingEstimate] ([shipEstimateID],[shippingEstimate],[leadTimeDays],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(3, '1-2 Days', 1, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ShippingEstimate] ([shipEstimateID],[shippingEstimate],[leadTimeDays],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(4, '3-5 Days', 3, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Store_ShippingEstimate] ([shipEstimateID],[shippingEstimate],[leadTimeDays],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(5, '1-2 Weeks', 7, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT dbo.[CSK_Store_ShippingEstimate] OFF
PRINT 'Finished inserting data in CSK_Store_ShippingEstimate'


SET IDENTITY_INSERT dbo.[CSK_Tax_Type] ON
PRINT 'Begin inserting data in CSK_Tax_Type'
INSERT INTO  dbo.[CSK_Tax_Type] ([taxTypeID],[taxType],[taxCode],[isExempt],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(1, 'Taxable Goods', 'REG', 0, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Tax_Type] ([taxTypeID],[taxType],[taxCode],[isExempt],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(2, 'Downloadable Goods', 'DOWN', 1, NULL, NULL, NULL, NULL)
INSERT INTO  dbo.[CSK_Tax_Type] ([taxTypeID],[taxType],[taxCode],[isExempt],[createdOn],[createdBy],[modifiedOn],[modifiedBy]) VALUES(3, 'Food Items', 'FOOD', 1, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT dbo.[CSK_Tax_Type] OFF
PRINT 'Finished inserting data in CSK_Tax_Type'


SET IDENTITY_INSERT dbo.[CSK_Util_Currency] ON
PRINT 'Begin inserting data in CSK_Util_Currency'
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(1, 'AFA', 'Afghanistan afghani')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(2, 'ALL', 'Albanian lek')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(3, 'DZD', 'Algerian dinar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(4, 'AOR', 'Angolan kwanza reajustado')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(5, 'ARS', 'Argentine peso')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(6, 'AMD', 'Armenian dram')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(7, 'AWG', 'Aruban guilder')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(8, 'AUD', 'Australian dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(9, 'AZN', 'Azerbaijanian new manat')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(10, 'BSD', 'Bahamian dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(11, 'BHD', 'Bahraini dinar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(12, 'BDT', 'Bangladeshi taka')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(13, 'BBD', 'Barbados dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(14, 'BYR', 'Belarusian ruble')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(15, 'BZD', 'Belize dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(16, 'BMD', 'Bermudian dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(17, 'BTN', 'Bhutan ngultrum')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(18, 'BOB', 'Bolivian boliviano')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(19, 'BWP', 'Botswana pula')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(20, 'BRL', 'Brazilian real')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(21, 'GBP', 'British pound')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(22, 'BND', 'Brunei dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(23, 'BGN', 'Bulgarian lev')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(24, 'BIF', 'Burundi franc')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(25, 'KHR', 'Cambodian riel')

INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(26, 'CAD', 'Canadian dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(27, 'CVE', 'Cape Verde escudo')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(28, 'KYD', 'Cayman Islands dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(29, 'XOF', 'CFA franc BCEAO')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(30, 'XAF', 'CFA franc BEAC')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(31, 'XPF', 'CFP franc')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(32, 'CLP', 'Chilean peso')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(33, 'CNY', 'Chinese yuan renminbi')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(34, 'COP', 'Colombian peso')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(35, 'KMF', 'Comoros franc')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(36, 'CDF', 'Congolese franc')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(37, 'CRC', 'Costa Rican colon')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(38, 'HRK', 'Croatian kuna')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(39, 'CUP', 'Cuban peso')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(40, 'CYP', 'Cypriot pound')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(41, 'CZK', 'Czech koruna')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(42, 'DKK', 'Danish krone')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(43, 'DJF', 'Djibouti franc')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(44, 'DOP', 'Dominican peso')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(45, 'XCD', 'East Caribbean dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(46, 'EGP', 'Egyptian pound')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(47, 'SVC', 'El Salvador colon')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(48, 'ERN', 'Eritrean nakfa')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(49, 'EEK', 'Estonian kroon')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(50, 'ETB', 'Ethiopian birr')

INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(51, 'EUR', 'EU euro')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(52, 'FKP', 'Falkland Islands pound')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(53, 'FJD', 'Fiji dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(54, 'GMD', 'Gambian dalasi')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(55, 'GEL', 'Georgian lari')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(56, 'GHC', 'Ghanaian cedi')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(57, 'GIP', 'Gibraltar pound')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(58, 'XAU', 'Gold (ounce)')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(59, 'XFO', 'Gold franc')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(60, 'GTQ', 'Guatemalan quetzal')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(61, 'GNF', 'Guinean franc')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(62, 'GYD', 'Guyana dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(63, 'HTG', 'Haitian gourde')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(64, 'HNL', 'Honduran lempira')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(65, 'HKD', 'Hong Kong SAR dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(66, 'HUF', 'Hungarian forint')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(67, 'ISK', 'Icelandic krona')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(68, 'XDR', 'IMF special drawing right')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(69, 'INR', 'Indian rupee')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(70, 'IDR', 'Indonesian rupiah')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(71, 'IRR', 'Iranian rial')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(72, 'IQD', 'Iraqi dinar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(73, 'ILS', 'Israeli new shekel')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(74, 'JMD', 'Jamaican dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(75, 'JPY', 'Japanese yen')

INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(76, 'JOD', 'Jordanian dinar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(77, 'KZT', 'Kazakh tenge')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(78, 'KES', 'Kenyan shilling')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(79, 'KWD', 'Kuwaiti dinar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(80, 'KGS', 'Kyrgyz som')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(81, 'LAK', 'Lao kip')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(82, 'LVL', 'Latvian lats')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(83, 'LBP', 'Lebanese pound')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(84, 'LSL', 'Lesotho loti')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(85, 'LRD', 'Liberian dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(86, 'LYD', 'Libyan dinar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(87, 'LTL', 'Lithuanian litas')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(88, 'MOP', 'Macao SAR pataca')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(89, 'MKD', 'Macedonian denar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(90, 'MGA', 'Malagasy ariary')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(91, 'MWK', 'Malawi kwacha')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(92, 'MYR', 'Malaysian ringgit')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(93, 'MVR', 'Maldivian rufiyaa')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(94, 'MTL', 'Maltese lira')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(95, 'MRO', 'Mauritanian ouguiya')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(96, 'MUR', 'Mauritius rupee')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(97, 'MXN', 'Mexican peso')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(98, 'MDL', 'Moldovan leu')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(99, 'MNT', 'Mongolian tugrik')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(100, 'MAD', 'Moroccan dirham')

INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(101, 'MZN', 'Mozambique new metical')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(102, 'MMK', 'Myanmar kyat')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(103, 'NAD', 'Namibian dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(104, 'NPR', 'Nepalese rupee')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(105, 'ANG', 'Netherlands Antillian guilder')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(106, 'NZD', 'New Zealand dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(107, 'NIO', 'Nicaraguan cordoba oro')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(108, 'NGN', 'Nigerian naira')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(109, 'KPW', 'North Korean won')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(110, 'NOK', 'Norwegian krone')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(111, 'OMR', 'Omani rial')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(112, 'PKR', 'Pakistani rupee')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(113, 'XPD', 'Palladium (ounce)')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(114, 'PAB', 'Panamanian balboa')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(115, 'PGK', 'Papua New Guinea kina')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(116, 'PYG', 'Paraguayan guarani')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(117, 'PEN', 'Peruvian nuevo sol')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(118, 'PHP', 'Philippine peso')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(119, 'XPT', 'Platinum (ounce)')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(120, 'PLN', 'Polish zloty')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(121, 'QAR', 'Qatari rial')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(122, 'RON', 'Romanian new leu')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(123, 'RUB', 'Russian ruble')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(124, 'RWF', 'Rwandan franc')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(125, 'SHP', 'Saint Helena pound')

INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(126, 'WST', 'Samoan tala')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(127, 'STD', 'Sao Tome and Principe dobra')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(128, 'SAR', 'Saudi riyal')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(129, 'CSD', 'Serbian dinar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(130, 'SCR', 'Seychelles rupee')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(131, 'SLL', 'Sierra Leone leone')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(132, 'XAG', 'Silver (ounce)')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(133, 'SGD', 'Singapore dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(134, 'SKK', 'Slovak koruna')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(135, 'SIT', 'Slovenian tolar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(136, 'SBD', 'Solomon Islands dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(137, 'SOS', 'Somali shilling')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(138, 'ZAR', 'South African rand')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(139, 'KRW', 'South Korean won')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(140, 'LKR', 'Sri Lanka rupee')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(141, 'SDD', 'Sudanese dinar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(142, 'SRD', 'Suriname dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(143, 'SZL', 'Swaziland lilangeni')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(144, 'SEK', 'Swedish krona')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(145, 'CHF', 'Swiss franc')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(146, 'SYP', 'Syrian pound')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(147, 'TWD', 'Taiwan New dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(148, 'TJS', 'Tajik somoni')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(149, 'TZS', 'Tanzanian shilling')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(150, 'THB', 'Thai baht')

INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(151, 'TOP', 'Tongan pa''anga')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(152, 'TTD', 'Trinidad and Tobago dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(153, 'TND', 'Tunisian dinar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(154, 'TRY', 'Turkish lira')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(155, 'TMM', 'Turkmen manat')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(156, 'AED', 'UAE dirham')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(157, 'UGX', 'Uganda new shilling')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(158, 'XFU', 'UIC franc')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(159, 'UAH', 'Ukrainian hryvnia')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(160, 'UYU', 'Uruguayan peso uruguayo')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(161, 'USD', 'US dollar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(162, 'UZS', 'Uzbekistani sum')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(163, 'VUV', 'Vanuatu vatu')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(164, 'VEB', 'Venezuelan bolivar')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(165, 'VND', 'Vietnamese dong')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(166, 'YER', 'Yemeni rial')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(167, 'ZMK', 'Zambian kwacha')
INSERT INTO  dbo.[CSK_Util_Currency] ([codeID],[code],[description]) VALUES(168, 'ZWD', 'Zimbabwe dollar')
SET IDENTITY_INSERT dbo.[CSK_Util_Currency] OFF
PRINT 'Finished inserting data in CSK_Util_Currency'


SET IDENTITY_INSERT [dbo].[CSK_Util_Country] ON
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (1, N'AF', N'Afghanistan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (2, N'AL', N'Albania')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (3, N'DZ', N'Algeria')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (4, N'AS', N'American Samoa')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (5, N'AD', N'Andorra')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (6, N'AO', N'Angola')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (7, N'AI', N'Anguilla')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (8, N'AQ', N'Antarctica')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (9, N'AG', N'Antigua and Barbuda')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (10, N'AR', N'Argentina')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (11, N'AM', N'Armenia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (12, N'AW', N'Aruba')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (13, N'AU', N'Australia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (14, N'AT', N'Austria')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (15, N'AZ', N'Azerbaijan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (16, N'BS', N'Bahamas')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (17, N'BH', N'Bahrain')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (18, N'BD', N'Bangladesh')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (19, N'BB', N'Barbados')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (20, N'BY', N'Belarus')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (21, N'BE', N'Belgium')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (22, N'BZ', N'Belize')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (23, N'BJ', N'Benin')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (24, N'BM', N'Bermuda')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (25, N'BT', N'Bhutan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (26, N'BO', N'Bolivia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (27, N'BA', N'Bosnia and Herzegovina')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (28, N'BW', N'Botswana')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (29, N'BV', N'Bouvet Island')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (30, N'BR', N'Brazil')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (31, N'IO', N'British Indian Ocean Territory')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (32, N'VG', N'British Virgin Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (33, N'BN', N'Brunei Darussalam')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (34, N'BG', N'Bulgaria')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (35, N'BF', N'Burkina Faso')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (36, N'BI', N'Burundi')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (37, N'KH', N'Cambodia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (38, N'CM', N'Cameroon')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (39, N'CA', N'Canada')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (40, N'CV', N'Cape Verde')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (41, N'KY', N'Cayman Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (42, N'CF', N'Central African Republic')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (43, N'TD', N'Chad')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (44, N'CL', N'Chile')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (45, N'CN', N'China')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (46, N'CX', N'Christmas Island')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (47, N'CC', N'Cocos')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (48, N'CO', N'Colombia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (49, N'KM', N'Comoros')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (50, N'CG', N'Congo')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (51, N'CK', N'Cook Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (52, N'CR', N'Costa Rica')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (53, N'HR', N'Croatia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (54, N'CU', N'Cuba')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (55, N'CY', N'Cyprus')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (56, N'CZ', N'Czech Republic')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (57, N'DK', N'Denmark')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (58, N'DJ', N'Djibouti')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (59, N'DM', N'Dominica')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (60, N'DO', N'Dominican Republic')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (61, N'TP', N'East Timor')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (62, N'EC', N'Ecuador')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (63, N'EG', N'Egypt')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (64, N'SV', N'El Salvador')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (65, N'GQ', N'Equatorial Guinea')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (66, N'ER', N'Eritrea')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (67, N'EE', N'Estonia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (68, N'ET', N'Ethiopia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (69, N'FK', N'Falkland Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (70, N'FO', N'Faroe Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (71, N'FJ', N'Fiji')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (72, N'FI', N'Finland')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (73, N'FR', N'France')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (74, N'GF', N'French Guiana')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (75, N'PF', N'French Polynesia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (76, N'TF', N'French Southern Territories')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (77, N'GA', N'Gabon')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (78, N'GM', N'Gambia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (79, N'GE', N'Georgia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (80, N'DE', N'Germany')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (81, N'GH', N'Ghana')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (82, N'GI', N'Gibraltar')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (83, N'GR', N'Greece')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (84, N'GL', N'Greenland')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (85, N'GD', N'Grenada')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (86, N'GP', N'Guadeloupe')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (87, N'GU', N'Guam')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (88, N'GT', N'Guatemala')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (89, N'GN', N'Guinea')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (90, N'GW', N'Guinea-Bissau')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (91, N'GY', N'Guyana')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (92, N'HT', N'Haiti')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (93, N'HM', N'Heard and McDonald Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (94, N'HN', N'Honduras')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (95, N'HK', N'Hong Kong')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (96, N'HU', N'Hungary')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (97, N'IS', N'Iceland')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (98, N'IN', N'India')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (99, N'ID', N'Indonesia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (100, N'IR', N'Iran')

print 'Processed 100 total records'
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (101, N'IQ', N'Iraq')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (102, N'IE', N'Ireland')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (103, N'IL', N'Israel')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (104, N'IT', N'Italy')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (105, N'CI', N'Ivory Coast')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (106, N'JM', N'Jamaica')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (107, N'JP', N'Japan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (108, N'JO', N'Jordan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (109, N'KZ', N'Kazakhstan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (110, N'KE', N'Kenya')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (111, N'KI', N'Kiribati')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (112, N'KW', N'Kuwait')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (113, N'KG', N'Kyrgyzstan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (114, N'LA', N'Laos')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (115, N'LV', N'Latvia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (116, N'LB', N'Lebanon')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (117, N'LS', N'Lesotho')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (118, N'LR', N'Liberia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (119, N'LY', N'Libya')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (120, N'LI', N'Liechtenstein')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (121, N'LT', N'Lithuania')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (122, N'LU', N'Luxembourg')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (123, N'MO', N'Macau')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (124, N'MK', N'Macedonia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (125, N'MG', N'Madagascar')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (126, N'MW', N'Malawi')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (127, N'MY', N'Malaysia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (128, N'MV', N'Maldives')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (129, N'ML', N'Mali')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (130, N'MT', N'Malta')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (131, N'MH', N'Marshall Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (132, N'MQ', N'Martinique')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (133, N'MR', N'Mauritania')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (134, N'MU', N'Mauritius')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (135, N'YT', N'Mayotte')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (136, N'MX', N'Mexico')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (137, N'FM', N'Micronesia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (138, N'MD', N'Moldova')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (139, N'MC', N'Monaco')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (140, N'MN', N'Mongolia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (141, N'MS', N'Montserrat')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (142, N'MA', N'Morocco')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (143, N'MZ', N'Mozambique')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (144, N'MM', N'Myanmar')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (145, N'NA', N'Namibia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (146, N'NR', N'Nauru')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (147, N'NP', N'Nepal')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (148, N'NL', N'Netherlands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (149, N'AN', N'Netherlands Antilles')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (150, N'NC', N'New Caledonia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (151, N'NZ', N'New Zealand')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (152, N'NI', N'Nicaragua')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (153, N'NE', N'Niger')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (154, N'NG', N'Nigeria')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (155, N'NU', N'Niue')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (156, N'NF', N'Norfolk Island')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (157, N'KP', N'North Korea')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (158, N'MP', N'Northern Mariana Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (159, N'NO', N'Norway')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (160, N'OM', N'Oman')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (161, N'PK', N'Pakistan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (162, N'PW', N'Palau')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (163, N'PA', N'Panama')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (164, N'PG', N'Papua New Guinea')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (165, N'PY', N'Paraguay')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (166, N'PE', N'Peru')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (167, N'PH', N'Philippines')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (168, N'PN', N'Pitcairn')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (169, N'PL', N'Poland')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (170, N'PT', N'Portugal')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (171, N'PR', N'Puerto Rico')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (172, N'QA', N'Qatar')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (173, N'RE', N'Reunion')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (174, N'RO', N'Romania')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (175, N'RU', N'Russian Federation')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (176, N'RW', N'Rwanda')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (177, N'GS', N'S. Georgia and S. Sandwich Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (178, N'KN', N'Saint Kitts and Nevis')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (179, N'LC', N'Saint Lucia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (180, N'VC', N'Saint Vincent and The Grenadines')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (181, N'WS', N'Samoa')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (182, N'SM', N'San Marino')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (183, N'ST', N'Sao Tome and Principe')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (184, N'SA', N'Saudi Arabia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (185, N'SN', N'Senegal')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (186, N'SC', N'Seychelles')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (187, N'SL', N'Sierra Leone')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (188, N'SG', N'Singapore')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (189, N'SK', N'Slovakia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (190, N'SI', N'Slovenia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (191, N'SB', N'Solomon Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (192, N'SO', N'Somalia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (193, N'ZA', N'South Africa')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (194, N'KR', N'South Korea')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (195, N'SU', N'Soviet Union')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (196, N'ES', N'Spain')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (197, N'LK', N'Sri Lanka')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (198, N'SH', N'St. Helena')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (199, N'PM', N'St. Pierre and Miquelon')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (200, N'SD', N'Sudan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (201, N'SR', N'Suriname')

print 'Processed 200 total records'
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (202, N'SJ', N'Svalbard and Jan Mayen Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (203, N'SZ', N'Swaziland')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (204, N'SE', N'Sweden')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (205, N'CH', N'Switzerland')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (206, N'SY', N'Syria')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (207, N'TW', N'Taiwan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (208, N'TJ', N'Tajikistan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (209, N'TZ', N'Tanzania')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (210, N'TH', N'Thailand')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (211, N'TG', N'Togo')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (212, N'TK', N'Tokelau')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (213, N'TO', N'Tonga')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (214, N'TT', N'Trinidad and Tobago')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (215, N'TN', N'Tunisia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (216, N'TR', N'Turkey')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (217, N'TM', N'Turkmenistan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (218, N'TC', N'Turks and Caicos Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (219, N'TV', N'Tuvalu')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (220, N'UG', N'Uganda')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (221, N'UA', N'Ukraine')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (222, N'AE', N'United Arab Emirates')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (223, N'GB', N'United Kingdom')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (224, N'US', N'United States')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (225, N'UY', N'Uruguay')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (226, N'UM', N'US Minor Outlying Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (227, N'VI', N'US Virgin Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (228, N'UZ', N'Uzbekistan')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (229, N'VU', N'Vanuatu')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (230, N'VE', N'Venezuela')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (231, N'VN', N'Viet Nam')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (232, N'WF', N'Wallis and Futuna Islands')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (233, N'EH', N'Western Sahara')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (234, N'YE', N'Yemen')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (235, N'YU', N'Yugoslavia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (236, N'ZR', N'Zaire')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (237, N'ZM', N'Zambia')
INSERT [dbo].[CSK_Util_Country] ([countryID], [code], [country]) VALUES (238, N'ZW', N'Zimbabwe')
SET IDENTITY_INSERT [dbo].[CSK_Util_Country] OFF
